{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Version I","Version II","Split Production","INSTRUCTIONS","INSTRUCTIONS OLD"],"not_rendered":{"macros":1,"external_links":1,"defined_names":33,"comments":49},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Version I","index":0,"n_rows":174,"n_cols":50,"rows_kept":174,"merged":[[2,1,2,17],[4,3,4,4],[4,7,4,8],[4,9,4,13],[4,14,4,18],[5,1,5,2],[5,3,5,7],[5,9,5,11],[5,12,5,13],[5,14,5,16],[6,14,6,16],[7,1,7,2],[7,14,7,16],[8,1,8,2],[8,14,8,16],[9,1,9,2],[9,14,9,16],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,3,14,4],[14,6,14,7],[14,9,14,10],[16,17,16,18],[17,17,17,18],[18,17,18,18],[19,17,19,18],[20,17,20,18],[21,17,21,18],[22,17,22,18],[23,17,23,18],[24,17,24,18],[25,17,25,18],[26,17,26,18],[27,17,27,18],[28,17,28,18],[29,17,29,18],[30,17,30,18],[31,17,31,18],[32,17,32,18],[33,17,33,18],[34,17,34,18],[35,17,35,18],[36,17,36,18],[37,17,37,18],[38,17,38,18],[39,17,39,18],[40,17,40,18],[41,17,41,18],[42,1,42,2],[42,3,42,4],[42,5,42,6],[42,8,42,10],[42,11,42,13],[42,16,42,18],[43,1,43,2],[43,3,43,4],[43,5,43,6],[43,9,43,10],[43,12,43,13],[43,17,43,18],[44,14,44,18],[45,2,46,10],[45,12,45,13],[45,16,45,17],[46,12,46,13],[46,16,46,17],[49,8,49,9],[65,1,65,2]],"flags":["formulas_cached_only"]}
[null,"REVISED","2006-07-31"]
[{"$nulls":9},"SPEC. YEAR  \"2006\""]
[null,"DENSITY  INCENTIVE / DISINCENTIVE  WORKSHEET  ",{"$nulls":18},"tons/sq yd"]
[]
[null,null,"S.P.",null,null,"HWY",null,"LOCATION",{"$nulls":6},"",{"$nulls":5},{"v":4.3,"d":"430.00%"},null,null,0]
[null,"CONTRACTOR",{"$nulls":7},"GYRATORY DESIGN",null,null,"",null,"",null,null,4300,null,null,"total tons"]
[{"$nulls":12},"PAVED",null,"MAT THICKNESS =",{"$nulls":5},1000]
[null,"SAMPLE NUMBER",{"$nulls":10},"CORED",null,"TOTAL TONS PAVED =",null,null,1000,null,null,"max density tons"]
[null,"SAMPLE TON #",{"$nulls":10},"BID PRICE=",{"v":35,"d":"$35.00"},"MAX. DENSITY TONS =",null,null,500,null,null,500]
[null,"TONS REPRESENTED",null,0,0,0,0,0,0,0,0,0,"MIX  TYPE  ","SPWER","INCENT/DISINC RATIO=",null,null,{"v":0.5,"d":"0.50"},null,null,"tons per lot",{"$nulls":5},1.22312]
[null,"DENSITY TONS",null,0,0,0,0,0,0,0,0,0,"Gmm.=",{"$error":"#N/A"},null,null,"OVERRIDE # LOTS = ",{"$nulls":3},500,{"$nulls":5},1.223,{"$nulls":9},""]
[null,"INDIVIDUAL VOIDS",{"$nulls":10},"TON TYPE ","ENGLISH","           LOTS REQUIRED =",null,null,1,null,null,"Adjusted Price per ton"]
[null,"IND. MAX SP.G."]
[null,"MOVNG AVG SP.G."]
[{"$nulls":3},"   DESIGN AIR VOIDS =",null,{"v":4,"d":"4.0"},"         MIN. AIR VOIDS =",null,3.5,"          REQ'D DENSITY=",null,{"v":91,"d":"91.0"},null,null,"            TONS PER LOT =",null,null,{"v":500,"d":"500.00"},null,null,{"v":35,"d":"35.00"}]
[{"$nulls":14},"",null,null,""]
[null,null,"CORE",null,"CORE/PAN",{"$nulls":4},"% WATER","Gmb /","BULK ","%","AIR VOID","TONS","Sq Yd","PAY","INCENTIVE"]
["LOT","CORE #","THICKNESS","AIR DRY","(or dry wt.)","PAN WT.","DRY WT.","SSD WT.","IMM WT.","ABSORBED","BULK SP.G","SpG. USED","DENSITY","USED","REPRESENT.","REPRESENT","FACTOR","DISINCENTIVE"]
[1,1.1,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,1.2,{"$nulls":4},{"v":0,"d":"0.0"},null,null,"",{"$error":"#NAME?"},{"$error":"#NAME?"},null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,0]
["COMP",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,"","",{"$nulls":7},{"$error":"#NAME?"},"= Ave.Gmb.",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
["","",{"$nulls":4},{"v":0,"d":"0.0"},null,null,"","","","","","",""," ",""]
[null,"",{"$nulls":4},{"v":0,"d":"0.0"},null,null,"","","",null,"","",""," ",""]
["",{"$nulls":5},{"v":0,"d":"0.0"},null,null,"",""," ",null,"","",""," ",""]
[null,null,"","",{"$nulls":7},"","","","",""," ",""]
["","",{"$nulls":4},"",null,null,"","","","","","",""," ",""]
[null,"",{"$nulls":4},"",null,null,"","","",null,"","",""," ",""]
[" ",{"$nulls":5},"",null,null,"",""," ",null,"","",""," ",""]
[null,null,"","",{"$nulls":7},"","","","",""," ",""]
["","",{"$nulls":4},"",null,null,"","","","","","",""," ",""]
[null,"",{"$nulls":4},"",null,null,"","","",null,"","",""," ",""]
[" ",{"$nulls":5},"",null,null,"",""," ",null,"","",""," ",""]
[null,null,"","",{"$nulls":7},"","","","",""," ",""]
["","",{"$nulls":4},"",null,null,"","","","","","",""," ",""]
[null,"",{"$nulls":4},"",null,null,"","","",null,"","",""," ",""]
[" ",{"$nulls":5},"",null,null,"",""," ",null,"","",""," ",""]
[null,null,"","",{"$nulls":7},"","","","",""," ",""]
["","",{"$nulls":4},"",null,null,"","","","","","",""," ",""]
[null,"",{"$nulls":4},"",null,null,"","","",null,"","",""," ",""]
[" ",{"$nulls":5},"",null,null,"",""," ",null,"","",""," ",""]
[null,null,"","",{"$nulls":7},"","","","",""," ",""]
[{"$error":"#NAME?"},"DATA  BY :",{"$nulls":3},"      Average Density =",null,{"$error":"#NAME?"},"INCENTIVE THIS SHEET",null,null,"DISINCENTIVE THIS SHEET",{"$nulls":4},"INCENTIVE / DISINCENTIVE"]
[null,"MIX DESIGNATION :",{"$nulls":3},"lbs.per square yd in.=",null,{"$error":"#NAME?"}," TOTAL =",{"$error":"#NAME?"},null," TOTAL =",{"$error":"#NAME?"},{"$nulls":3},"NET Total =",{"$error":"#NAME?"}]
[null,"NOTES",{"$nulls":12},"Weighted Average Air Voids"]
[{"$nulls":11},"CHK'D BY",null,null,"DATE :"]
[{"$nulls":11},"PLANT # :",null,null,"MDR.# :"]
[]
[]
[]
[{"$nulls":5},"Would you like to calculate and use the weighted average"]
[{"$nulls":5},"of the production air voids, rather than using the individual "]
[{"$nulls":5},"air voids?  The incentive/disincentive calculated using this"]
[{"$nulls":5},"option is to be used for information only.  The specification "]
[{"$nulls":5},"calls for using the individual air voids and the weighted average",{"$nulls":15},"yes"]
[{"$nulls":5},"method should NOT be used to calculate the actual ",{"$nulls":15},"no"]
[{"$nulls":5},"incentive/disincentive to be paid to the contractor."]
[{"$nulls":21},2350,2350,2350,2360,2360,2360]
[{"$nulls":5},"I would like to use the weighted average of the air voids - ",{"$nulls":5},"yes",{"$nulls":8},"%DENS.",-1,2,"RED. (3)","upper 4\" (4)","lower 4\"(5)",6]
[{"$nulls":21},"hv","MV LV"," MV LV",">4\" REDUCED",null,"up 4\" red.",null,null,"MIN.VOID","REQ. DENS.","DEN.COL.","INCENT*","VOID LIMIT"]
[{"$nulls":6},"air void weighted average = ",null,null,{"$error":"#NAME?"},{"$nulls":12},"SP WEAR,SHLD","SP WEAR,SHLD",{"$nulls":4},"LV",2.5,{"v":92,"d":"92.0"},2,2,1]
[{"$nulls":20},87,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"LVR",2.5,{"v":91,"d":"91.0"},3,2,1,{"$nulls":10},"TONS PAVED (metric) =",null,500,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
[{"$nulls":20},87.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MV",{"v":3,"d":"3.0"},{"v":92,"d":"92.0"},2,2,2,{"$nulls":10},"     LOTS tested =",null,1,null,500.1,{"v":0,"d":"0.00"}]
[{"$nulls":20},87.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MVR",{"v":3,"d":"3.0"},{"v":91,"d":"91.0"},3,2,2,{"$nulls":10},"        TONS PER LOT=",null,{"v":500,"d":"500.00"},null,500.1,{"v":0,"d":"0.00"}]
["max",null,"a",1,2,3,4,5,6,7,8,9,{"$nulls":8},87.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNW",2.5,{"v":93,"d":"93.0"},5,2,1,"NONWEAR",1,{"$nulls":10},3.5,null,500.1,{"v":0,"d":"0.00"}]
["average","average mx spg",null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$nulls":8},87.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNWR",2.5,{"v":92,"d":"92.0"},6,1,1,"NW",1,{"$nulls":6},"",null,{"v":35,"d":"$35.00"},null,{"v":91,"d":"91.0"},null,500.1,{"v":0,"d":"0.00"}]
[null,"is average available",null,0,0,0,0,0,0,0,0,0,{"$nulls":8},87.5,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3",2.5,93,5,2,1,"WEAR",2,{"$nulls":12},500.1,{"v":0,"d":"0.00"}]
[null,"number of max's",null,0,{"$nulls":16},87.6,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3R",2.5,92,6,1,1,{"$nulls":14},500.1,{"v":0,"d":"0.00"}]
[{"$nulls":20},87.7,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4",3.5,92,2,2,3,{"$nulls":14},500.1,{"v":0,"d":"0.00"}]
[null,"look up the avg",null,{"$error":"#N/A"},{"$nulls":16},87.8,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4R",3.5,91,3,2,2,"VOID LIMIT",3,"Q/C","SAMPLE #",1,2,3,4,5,6,7,8,9,null,500.1,{"v":0,"d":"0.00"}]
[{"$nulls":20},87.9,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWE",3.5,{"v":92,"d":"92.0"},2,2,3,"DENSITY",3,"SAMPLES","TON #",0,0,0,0,0,0,0,0,0,null,500.1]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,{"$nulls":8},88,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWER",3.5,{"v":91,"d":"91.0"},3,2,3,"INCENT.",2,null,"TONS REP.",0,0,0,0,0,0,0,0,0]
[{"$nulls":3},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"$nulls":8},88.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"INCENT* - 1 = N0, 2 = YES",{"$nulls":6},"MAX TONS",0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,0,0,0,0,0,0,0,0,{"$nulls":8},88.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"VOID LIMIT - 3 = 3.5%MIN, 2 = 3%MIN, 1 = 2.5%MIN.",{"$nulls":6},"AIR VOIDS",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},0,{"$nulls":16},88.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"ENGLISH",{"$nulls":20},{"v":500,"d":"500.0"}]
[{"$nulls":3},{"$error":"#N/A"},{"$nulls":16},88.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"METRIC",{"$nulls":4},"LOT #",{"$nulls":6},"PRICE  ADJ.","DENSITY","AIR VOID","TONS","FACTOR","in/dis",{"$nulls":3},{"v":500,"d":"500.0"}]
[{"$nulls":20},88.5,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},1,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.6,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":7},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,{"$error":"#NAME?"},{"$error":"#NAME?"},null,"","",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.7,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"english",2,null,"ton type",null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,{"$error":"#NAME?"},null,"","",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.8,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"metric",1,null,2,{"$nulls":8},{"$error":"#NAME?"},null,"","",{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.9,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},2,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},{"v":89,"d":"89.0"},-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#VALUE!"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},89.1,-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,"Tons","Lots","ENGLISH",{"$nulls":3},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},89.2,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,0.1,0,0.1,0,{"$nulls":8},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},89.3,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,1,1,1,1,null,3,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.4,-0.15,-0.3,-0.09,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,546,2,601,2,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#VALUE!"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.5,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,911,3,1001,3,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.6,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,1456,4,1601,4,{"$nulls":8},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.7,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,3276,5,3601,5,null,4,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},89.8,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,4546,6,5001,6,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#VALUE!"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},89.9,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,9999,6,9999,6,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},90,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},90.1,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":6},5,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.2,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#VALUE!"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.3,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.4,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.5,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":6},6,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.9899999999998,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.6,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#VALUE!"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.7,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.8,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.9,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05]
[{"$nulls":20},91,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.1,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.2,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"SAMPLE ","LOT 1","LOT 2","LOT 3","LOT 4","LOT 5","LOT 6",null,"S.P."]
[{"$nulls":20},91.3,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"TON",{"$nulls":7},"S.A.P"]
[{"$nulls":20},91.4,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"samples",{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,"C.P."]
[{"$nulls":20},91.5,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,2]
[{"$nulls":20},91.6,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,"LV","MARSHALL DESIGN"]
[{"$nulls":20},91.7,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,"LVR","MARSHALL DESIGN"]
[{"$nulls":20},91.8,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,"MV","MARSHALL DESIGN"]
[{"$nulls":20},91.9,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},"","","","","","",null,"MVR","MARSHALL DESIGN"]
[{"$nulls":20},92,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":0,"d":"0.00"},"","","","","","",null,"SPNW","GYRATORY DESIGN"]
[{"$nulls":20},92.1,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":0,"d":"0.00"},"","","","","","",null,"SPNWR","GYRATORY DESIGN"]
[{"$nulls":20},92.2,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":0,"d":"0.00"},"","","","","","",null,"SPSHLD3","GYRATORY DESIGN"]
[{"$nulls":20},92.3,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,"SPSHLD4","GYRATORY DESIGN"]
[{"$nulls":20},92.4,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD3R","GYRATORY DESIGN"]
[{"$nulls":20},92.5,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD4R","GYRATORY DESIGN"]
[{"$nulls":20},92.6,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPWE","GYRATORY DESIGN"]
[{"$nulls":20},92.7,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,"SPWER","GYRATORY DESIGN"]
[{"$nulls":20},92.8,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,1,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[{"$nulls":20},92.9,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[{"$nulls":20},93,0.02,0,0,{"v":0,"d":"0.00"},0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[{"$nulls":20},93.1,0.04,0.02,0,0.02,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[{"$nulls":20},93.2,0.04,0.02,0,0.02,0,0,null,null,"","","","","","",null,2,"",""]
[{"$nulls":20},93.3,0.04,0.02,0,0.02,0,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},93.4,0.04,0.02,0,0.02,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"",""]
[{"$nulls":20},93.5,0.04,0.02,0,0.02,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},93.6,0.04,0.04,0,0.04,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,3,"",""]
[{"$nulls":20},93.7,0.04,0.04,0,0.04,0,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},93.8,0.04,0.04,0,0.04,0,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},93.9,0.04,0.04,0,0.04,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},{"v":94,"d":"94.0"},0.04,0.04,0,0.04,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,4,"",""]
[{"$nulls":20},94.1,0.04,0.04,0,0.04,0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},94.2,0.04,0.04,0,0.04,0.02,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},94.3,0.04,0.04,0,0.04,0.02,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},94.3999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,5,"",""]
[{"$nulls":20},94.4999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},94.5999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},94.6999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},94.7999999999999,0.04,0.04,0,0.04,0.04,0,{"$nulls":9},6,"",""]
[{"$nulls":20},94.8999999999999,0.04,0.04,0,0.04,0.04,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},94.9999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},95.0999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.1999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.2999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","","",null,null,{"$error":"#NAME?"},{"$error":"#NAME?"}]
[{"$nulls":20},{"v":95.3999999999999,"d":"95.4"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":95.4999999999999,"d":"95.5"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.9899999999998,"d":"500.0"}]
[{"$nulls":20},{"v":95.5999999999999,"d":"95.6"},0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},{"v":95.6999999999998,"d":"95.7"},0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.7999999999998,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.8999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},95.9999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.0999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.3999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.4999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.5999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.6999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.7999999999998,"d":"96.8"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.8999999999998,"d":"96.9"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.9999999999998,"d":"97.0"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":97.0999999999998,"d":"97.1"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.3999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.4999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.5999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.6999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]

{"sheet":"Version II","index":1,"n_rows":181,"n_cols":50,"rows_kept":181,"merged":[[1,0,1,13],[2,0,2,13],[4,3,4,4],[4,5,4,6],[4,7,4,12],[5,1,5,2],[5,3,5,4],[5,10,5,12],[5,15,5,16],[7,1,7,2],[7,4,7,5],[7,7,7,11],[8,1,8,2],[8,4,8,5],[8,11,8,12],[9,1,9,2],[9,4,9,5],[10,1,10,2],[10,4,10,5],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,3,19,4],[19,6,19,7],[19,10,19,11],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,10,46,13],[47,1,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,11,47,13],[48,1,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,10,48,13],[49,16,49,18],[50,2,53,12],[50,16,50,17],[56,8,56,10],[70,1,70,2]],"flags":["formulas_cached_only"]}
[null,"REVISED","2006-07-31"]
["SPEC. YEAR  \"2006\""]
["DENSITY  INCENTIVE / DISINCENTIVE   WORKSHEET  "]
[]
[null,null,"S.P.",null,null,"LOCATION",{"$nulls":17},0]
[null,"CONTRACTOR",{"$nulls":3},"PAVED",null,"CORED",null,null,"GYRATORY DESIGN"]
[]
[null,"BID PRICE=",null,{"v":35,"d":"$35.00"},"MAT THICKNESS =",null,null,""]
[null,"MIX  TYPE = ",null,"SPWER","TOTAL TONS PAVED =",null,1000,null,"OVERRIDE # LOTS = ",null,null,""]
[null,"Ave.Gmm.=",null,{"$error":"#N/A"},"MAX. DENSITY TONS =",null,500,"           LOTS REQUIRED =",null,1,null,null,5000]
[null,"TON TYPE ",null,"ENGLISH","INCENT/DISINC RATIO=",null,{"v":0.5,"d":"0.50"},"            TONS PER LOT =",null,{"v":500,"d":"500.00"}]
[{"$nulls":7},"",null,""]
[null,"SAMPLE NUMBER",{"$nulls":13},"total tons"]
[null,"SAMPLE TON #",{"$nulls":13},1000]
[null,"TONS REPRESENTED",null,0,0,0,0,0,0,0,0,0,{"$nulls":3},"max density tons"]
[null,"DENSITY TONS",null,0,0,0,0,0,0,0,0,0,{"$nulls":3},500,{"$nulls":20},""]
[null,"INDIVIDUAL VOIDS",{"$nulls":13},"tons per lot"]
[null,"IND. MAX SP.G."]
[null,"MVNG AVG MX SP.G."]
[{"$nulls":3},"   DESIGN AIR VOIDS =",null,{"v":4,"d":"4.0"},"         MIN. AIR VOIDS =",null,3.5,null,"          REQ'D DENSITY=",null,{"v":91,"d":"91.0"},null,null,500]
[{"$nulls":3},"CORE","Gmb /","BULK ","%","AIR VOID","TONS","Sq Yds","PAY","INCENTIVE",{"$nulls":3},"Adjusted Price per ton"]
[null,"LOT","CORE #","THICKNESS","BULK SP.G","SpG. USED","DENSITY","USED","REPRESENT.","REPRESENT","FACTOR","DISINCENTIVE",{"$nulls":3},{"v":35,"d":"35.00"}]
[null,1,1.1,null,null,"","","","",""," ",""]
[null,null,1.2,null,null,"",null,"","",""," ","",{"$nulls":3},0]
[null,"COMP",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","= Ave.Gmb.","","",""," ",""]
[null,"","",null,null,"","","","",""," ",""]
[null,null,"",null,null,"",null,"","",""," ",""]
[null,"",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","","","",""," ",""]
[null,"","",null,null,"","","","",""," ",""]
[null,null,"",null,null,"",null,"","",""," ",""]
[null," ",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","","","",""," ",""]
[null,"","",null,null,"","","","",""," ",""]
[null,null,"",null,null,"",null,"","",""," ",""]
[null," ",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","","","",""," ",""]
[null,"","",null,null,"","","","",""," ",""]
[null,null,"",null,null,"",null,"","",""," ",""]
[null," ",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","","","",""," ",""]
[null,"","",null,null,"","","","",""," ",""]
[null,null,"",null,null,"",null,"","",""," ",""]
[null," ",{"$nulls":3}," ",null,"","",""," ",""]
[{"$nulls":3},"",null,"","","","",""," ",""]
[null,"DATE:",{"$nulls":3},"CHECKED BY:",{"$nulls":4},"INCENTIVE / DISINCENTIVE"]
[null,"DATA  BY :",{"$nulls":3},"MIX DESIGNATION :",{"$nulls":4},"NET =",{"v":0,"d":"$0.00"}]
[null,"Average Density =",null,{"$error":"#DIV/0!"},null,"lbs.per square yd in.=",null,{"$error":"#DIV/0!"},null,null,"Weighted Average Air Voids"]
[]
[null,"NOTES"]
[null,{"$error":"#NAME?"}]
[]
[]
[]
[]
[]
[{"$nulls":3},"Would you like to calculate and use the weighted average"]
[{"$nulls":3},"of the production air voids, rather than using the individual "]
[{"$nulls":3},"air voids?  The incentive/disincentive calculated using this"]
[{"$nulls":3},"option is to be used for information only.  The specification "]
[{"$nulls":3},"calls for using the individual air voids and the weighted average"]
[{"$nulls":3},"method should NOT be used to calculate the actual ",{"$nulls":25},"yes"]
[{"$nulls":3},"incentive/disincentive to be paid to the contractor.",{"$nulls":25},"no"]
[{"$nulls":21},2350,2350,2350,2360,2360,2360]
[{"$nulls":3},"I would like to use the weighted average of the air voids - ",{"$nulls":6},"yes",{"$nulls":9},"%DENS.",-1,2,"RED. (3)","upper 4\" (4)","lower 4\"(5)",6]
[{"$nulls":21},"hv","MV LV"," MV LV",">4\" REDUCED",null,"up 4\" red.",null,null,"MIN.VOID","REQ. DENS.","DEN.COL.","INCENT*","VOID LIMIT"]
[{"$nulls":4},"air void weighted average = ",null,null,{"$error":"#NAME?"},{"$nulls":14},"SP WEAR,SHLD","SP WEAR,SHLD",{"$nulls":4},"LV",2.5,{"v":92,"d":"92.0"},2,2,1]
[{"$nulls":20},87,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"LVR",2.5,{"v":91,"d":"91.0"},3,2,1,{"$nulls":10},"TONS PAVED (metric) =",null,500,null,{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
["max",null,"a",1,2,3,4,5,6,7,8,9,{"$nulls":8},87.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MV",{"v":3,"d":"3.0"},{"v":92,"d":"92.0"},2,2,2,{"$nulls":10},"     LOTS tested =",null,1,null,500.1,{"v":0,"d":"0.00"}]
["average","average mx spg",null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$nulls":8},87.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"MVR",{"v":3,"d":"3.0"},{"v":91,"d":"91.0"},3,2,2,{"$nulls":10},"        TONS PER LOT=",null,{"v":500,"d":"500.00"},null,500.1,{"v":0,"d":"0.00"}]
[null,"is average available",null,0,0,0,0,0,0,0,0,0,{"$nulls":8},87.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNW",2.5,{"v":93,"d":"93.0"},5,2,1,"NONWEAR",1,{"$nulls":10},3.5,null,500.1,{"v":0,"d":"0.00"}]
[null,"number of max's",null,0,{"$nulls":16},87.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPNWR",2.5,{"v":92,"d":"92.0"},6,1,1,"NW",1,{"$nulls":6},"",null,{"v":35,"d":"$35.00"},null,{"v":91,"d":"91.0"},null,500.1,{"v":0,"d":"0.00"}]
[{"$nulls":20},87.5,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3",2.5,93,5,2,1,"WEAR",2,{"$nulls":12},500.1,{"v":0,"d":"0.00"}]
[null,"look up the avg",null,{"$error":"#N/A"},{"$nulls":16},87.6,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD3R",2.5,92,6,1,1,{"$nulls":14},500.1,{"v":0,"d":"0.00"}]
[{"$nulls":20},87.7,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4",3.5,92,2,2,3,{"$nulls":14},500.1,{"v":0,"d":"0.00"}]
[{"$nulls":3},1,2,3,4,5,6,7,8,9,{"$nulls":8},87.8,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPSHLD4R",3.5,91,3,2,2,"VOID LIMIT",3,"Q/C","SAMPLE #",1,2,3,4,5,6,7,8,9,null,500.1,{"v":0,"d":"0.00"}]
[{"$nulls":3},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"$nulls":8},87.9,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWE",3.5,{"v":92,"d":"92.0"},2,2,3,"DENSITY",3,"SAMPLES","TON #",0,0,0,0,0,0,0,0,0,null,500.1]
[{"$nulls":3},0,0,0,0,0,0,0,0,0,{"$nulls":8},88,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"SPWER",3.5,{"v":91,"d":"91.0"},3,2,3,"INCENT.",2,null,"TONS REP.",0,0,0,0,0,0,0,0,0]
[{"$nulls":3},0,{"$nulls":16},88.1,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"INCENT* - 1 = N0, 2 = YES",{"$nulls":6},"MAX TONS",0,0,0,0,0,0,0,0,0]
[{"$nulls":3},{"$error":"#N/A"},{"$nulls":16},88.2,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":3},"VOID LIMIT - 3 = 3.5%MIN, 2 = 3%MIN, 1 = 2.5%MIN.",{"$nulls":6},"AIR VOIDS",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":20},88.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"ENGLISH",{"$nulls":20},{"v":500,"d":"500.0"}]
[{"$nulls":20},88.4,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"METRIC",{"$nulls":4},"LOT #",{"$nulls":6},"PRICE  ADJ.","DENSITY","AIR VOID","TONS","FACTOR","in/dis",{"$nulls":3},{"v":500,"d":"500.0"}]
[{"$nulls":20},88.5,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},1,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.6,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.7,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"english",2,null,"ton type",null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.8,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",null,"metric",1,null,2,{"$nulls":8},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":499.99,"d":"500.0"}]
[{"$nulls":20},88.9,-0.3,"SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.","SEE SPEC.",{"$nulls":6},2,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},{"v":89,"d":"89.0"},-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},89.1,-0.15,-0.3,-0.3,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,"Tons","Lots","ENGLISH",{"$nulls":3},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},89.2,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,0.1,0,0.1,0,{"$nulls":8},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":999.98,"d":"1000.0"}]
[{"$nulls":20},89.3,-0.15,-0.3,-0.15,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,1,1,1,1,null,3,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.4,-0.15,-0.3,-0.09,{"v":-0.3,"d":"-0.30"},"SEE SPEC.",-0.3,null,546,2,601,2,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.5,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,911,3,1001,3,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.6,-0.09,-0.15,-0.09,-0.15,"SEE SPEC.",-0.15,null,1456,4,1601,4,{"$nulls":8},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1499.97,"d":"1500.0"}]
[{"$nulls":20},89.7,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,3276,5,3601,5,null,4,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},89.8,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,4546,6,5001,6,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},89.9,-0.09,-0.15,-0.05,-0.15,"SEE SPEC.",-0.15,null,9999,6,9999,6,null,null,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},90,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":1999.96,"d":"2000.0"}]
[{"$nulls":20},90.1,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":6},5,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.99,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.2,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.3,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.4,-0.05,-0.09,-0.02,-0.09,{"v":-0.3,"d":"-0.30"},-0.09,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2499.95,"d":"2500.0"}]
[{"$nulls":20},90.5,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":6},6,{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"v":0,"d":"0.000"},{"$error":"#N/A"},"",{"$error":"#NAME?"},{"v":499.9899999999998,"d":"500.0"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#NAME?"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.6,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"v":0,"d":"0.000"},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.7,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":7},{"$error":"#NAME?"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.8,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05,{"$nulls":13},{"$error":"#N/A"},null,"","",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"v":2999.9399999999996,"d":"2999.9"}]
[{"$nulls":20},90.9,-0.02,-0.05,-0.02,-0.05,-0.15,-0.05]
[{"$nulls":20},91,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.1,-0.02,-0.02,0,-0.02,-0.09,-0.02]
[{"$nulls":20},91.2,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"SAMPLE ","LOT 1","LOT 2","LOT 3","LOT 4","LOT 5","LOT 6",null,"S.P."]
[{"$nulls":20},91.3,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"TON",{"$nulls":7},"S.A.P"]
[{"$nulls":20},91.4,-0.02,-0.02,0,-0.02,-0.09,-0.02,null,"samples",{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,"C.P."]
[{"$nulls":20},91.5,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,2]
[{"$nulls":20},91.6,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,"LV","MARSHALL DESIGN"]
[{"$nulls":20},91.7,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,"LVR","MARSHALL DESIGN"]
[{"$nulls":20},91.8,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},"","","","","",null,"MV","MARSHALL DESIGN"]
[{"$nulls":20},91.9,0,-0.02,0,-0.02,-0.05,-0.02,null,{"v":0,"d":"0.00"},"","","","","","",null,"MVR","MARSHALL DESIGN"]
[{"$nulls":20},92,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":0,"d":"0.00"},"","","","","","",null,"SPNW","GYRATORY DESIGN"]
[{"$nulls":20},92.1,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":0,"d":"0.00"},"","","","","","",null,"SPNWR","GYRATORY DESIGN"]
[{"$nulls":20},92.2,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,{"v":0,"d":"0.00"},"","","","","","",null,"SPSHLD3","GYRATORY DESIGN"]
[{"$nulls":20},92.3,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,"SPSHLD4","GYRATORY DESIGN"]
[{"$nulls":20},92.4,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD3R","GYRATORY DESIGN"]
[{"$nulls":20},92.5,0,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPSHLD4R","GYRATORY DESIGN"]
[{"$nulls":20},92.6,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"SPWE","GYRATORY DESIGN"]
[{"$nulls":20},92.7,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,"SPWER","GYRATORY DESIGN"]
[{"$nulls":20},92.8,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,1,"",""]
[{"$nulls":20},92.9,0.02,0,0,{"v":0,"d":"0.00"},-0.02,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"",""]
[{"$nulls":20},93,0.02,0,0,{"v":0,"d":"0.00"},0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"",""]
[{"$nulls":20},93.1,0.04,0.02,0,0.02,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},93.2,0.04,0.02,0,0.02,0,0,null,null,"","","","","","",null,2,"",""]
[{"$nulls":20},93.3,0.04,0.02,0,0.02,0,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},93.4,0.04,0.02,0,0.02,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"",""]
[{"$nulls":20},93.5,0.04,0.02,0,0.02,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},93.6,0.04,0.04,0,0.04,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,3,"",""]
[{"$nulls":20},93.7,0.04,0.04,0,0.04,0,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},93.8,0.04,0.04,0,0.04,0,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},93.9,0.04,0.04,0,0.04,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},{"v":94,"d":"94.0"},0.04,0.04,0,0.04,0,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,4,"",""]
[{"$nulls":20},94.1,0.04,0.04,0,0.04,0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},94.2,0.04,0.04,0,0.04,0.02,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},94.3,0.04,0.04,0,0.04,0.02,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},94.3999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,5,"",""]
[{"$nulls":20},94.4999999999999,0.04,0.04,0,0.04,0.02,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},94.5999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},94.6999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","","",null,null,"",""]
[{"$nulls":20},94.7999999999999,0.04,0.04,0,0.04,0.04,0,{"$nulls":9},6,"",""]
[{"$nulls":20},94.8999999999999,0.04,0.04,0,0.04,0.04,0,null,null,0.01,500.01,1000.01,1500.01,2000.01,2500.01,null,null,"",""]
[{"$nulls":20},94.9999999999999,0.04,0.04,0,0.04,0.04,0,null,null,{"v":500,"d":"500.00"},{"v":1000,"d":"1000.00"},{"v":1500,"d":"1500.00"},{"v":2000,"d":"2000.00"},{"v":2500,"d":"2500.00"},{"v":3000,"d":"3000.00"},null,null,"",""]
[{"$nulls":20},95.0999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.1999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.2999999999999,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","","",null,null,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$nulls":20},{"v":95.3999999999999,"d":"95.4"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":95.4999999999999,"d":"95.5"},0.04,0.04,0,0.04,0.04,0,null,null,{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.99,"d":"500.0"},{"v":499.9899999999998,"d":"500.0"}]
[{"$nulls":20},{"v":95.5999999999999,"d":"95.6"},0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},{"v":95.6999999999998,"d":"95.7"},0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.7999999999998,0.04,0.04,0,0.04,0.04,0,null,null,"","","","","",""]
[{"$nulls":20},95.8999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},95.9999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.0999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.3999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.4999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.5999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},96.6999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.7999999999998,"d":"96.8"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.8999999999998,"d":"96.9"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":96.9999999999998,"d":"97.0"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},{"v":97.0999999999998,"d":"97.1"},0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.1999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.2999999999998,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.3999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.4999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.5999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":20},97.6999999999997,0.04,0.04,0,0.04,0.04,0]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]
[{"$nulls":22},0.04]

{"sheet":"Split Production","index":2,"n_rows":50,"n_cols":19,"rows_kept":50,"merged":[[6,2,6,3],[7,2,7,3],[7,8,7,11],[8,2,8,3],[10,2,10,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,4,18,5],[18,7,18,8],[18,10,18,11],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[25,11,25,12],[26,2,26,3],[27,2,27,3],[29,2,29,3],[29,5,29,6],[30,11,30,12],[31,2,31,3],[32,2,32,3],[33,2,33,3],[35,11,35,12],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,11,39,12],[40,2,40,3],[41,2,41,3],[42,2,42,3],[45,2,45,3],[45,5,45,6],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9],[53,10,53,13],[54,2,54,3],[54,4,54,5],[54,6,54,7],[54,8,54,9],[54,11,54,13],[55,2,55,3],[55,4,55,5],[55,6,55,7],[55,8,55,9],[57,3,57,12],[57,16,57,18],[58,3,58,12],[58,16,58,17],[60,3,60,12],[63,9,63,10]],"flags":["formulas_cached_only"]}
[]
[null,null,"Split Production  -  The following worksheet can be used when a day's production needs to be split due to "]
[null,null,"different density requirements or similar situations.  Area \"A\" is defined as the first area paved from the start "]
[null,null,"of that day's production and Area \"B\" is the remaining tonnage for that day's production.  The number of lots",{"$nulls":14},"ENGLISH"]
[null,null,"required for each area may be manually entered on each worksheet.  The intent is to not have more lots tested ",{"$nulls":14},0.1,0]
[null,null,"than the required amount for the total day's production.",{"$nulls":14},1,1]
[{"$nulls":17},601,2]
[{"$nulls":5},"DAILY TOTAL TONS PAVED =",null,6000,"      # OF LOTS REQ'D FOR DAILY TOTAL =",{"$nulls":3},6,{"$nulls":4},1001,3]
[{"$nulls":5},"AREA \"A\" -  TONS PAVED =",null,2150,{"$nulls":9},1601,4]
[{"$nulls":5},"AREA \"B\" -  TONS PAVED =",null,3850,{"$nulls":9},3601,5]
[{"$nulls":4},"COMPLETE TEST DATA TAKEN FROM THE TEST SUMMARY SHEETS",{"$nulls":12},5001,6]
[]
[null,null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309]
[null,null,"SAMPLE TON #",null,650,1567,2400,2820,3444,4001,4567,5221,5900]
[null,"B","TONS - 1ST SECTION",null,2150,2150,2150,2150,2150,2150,2150,2150,2150]
[null,"C","SAMPLE TON # 1ST SECT.",null,650,1567,2000,2000,2000,2000,2000,2000,2000]
[null,"D","SAMPLE TON # 2nd SECT.",null,0,0,400,8200,1444,2001,2567,3221,3900]
[null,null,"INDIVIDUAL VOIDS",null,3.8,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"}]
[]
[]
[null,"A",{"$nulls":16},4]
[null,"B","The number of tons that represent the first section.  Insert this value in the total tons paved.",{"$nulls":15},5]
[null,"C","Compare the A and B values, insert the lessor value.",{"$nulls":15},6]
[null,"D","C minus A",{"$nulls":15},6]
[]
[]
[null,null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309]
[null,null,"SAMPLE TON #",null,650,1567,2150,2150,2150,2150,2150,2150,2150]
[]
[null,null,"AREA \"A\"",null,"Notes","TOTAL TONS PAVED =",null,2150,null,"NUMBER OF LOTS - MANUAL =",null,2]
[]
[null,null,"SAMPLE NUMBER",null,301,302,"","","","","","",""]
[null,null,"SAMPLE TON #",null,650,1567,"","","","","","",""]
[null,null,"INDIVIDUAL VOIDS",null,3.8,3.7,"","","","","","",""]
[]
[]
[null,null,"SAMPLE NUMBER",null,301,302,303,304,305,306,307,308,309]
[null,null,"SAMPLE TON #",null,0,0,250,670,1294,1851,2417,3071,3750]
[null,null,"INDIVIDUAL VOIDS",null,3.8,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"}]
[]
[null,null,"SAMPLE NUMBER",null,302,303,304,305,306,307,308,309,310]
[null,null,"SAMPLE TON #",null,0,250,670,1294,1851,2417,3071,3750,3750]
[null,null,"INDIVIDUAL VOIDS",null,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"},{"v":2,"d":"2.0"}]
[]
[]
[null,null,"AREA \"B\"",null,null,"TOTAL TONS PAVED =",null,3850,null,"NUMBER OF LOTS - MANUAL =",null,4]
[]
[null,null,"SAMPLE NUMBER",null,302,303,304,305,306,307,308,309,""]
[null,null,"SAMPLE TON #",null,0,250,670,1294,1851,2417,3071,3750,""]
[null,null,"INDIVIDUAL VOIDS",null,3.7,4.1,3.7,{"v":3,"d":"3.0"},{"v":2,"d":"2.0"},{"v":5,"d":"5.0"},4.4,{"v":2,"d":"2.0"},""]

{"sheet":"INSTRUCTIONS","index":3,"n_rows":105,"n_cols":3,"rows_kept":105,"merged":[[3,0,3,9],[60,1,62,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
["IMPROVEMENTS TO THE INCENTIVE / DISINCENTIVE PROGRAM"]
[]
[null,"THIS PROGRAM HAS BEEN MODIFIED TO ALLOW WORKSHEETS"]
[null,"TO BE COPIED WITHIN THE WORKBOOK,  THEREFORE ONE"]
[null,"WORKBOOK (OR FILE) CAN CONTAIN SEVERAL DAYS OF PAVING."]
[]
[null,"THE DATA FOR DAY #1 SHOULD BE ENTERED ON THE  SHEET"]
[null,"LABELED \"day (1)\".  FOR DAYS THAT FOLLOW, MAKE A COPY"]
[null,"OF THIS SHEET BY USING ONE OF THE FOLLOWING THREE METHODS."]
[]
[null,"METHOD  1"]
[null,"CLICK ON THE BUTTON TO THE RIGHT"]
[]
[null,null,"OR"]
[]
[null,"METHOD  2"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THE  "]
[null,"HOLD THE CTRL (CONTROL) DOWN AND THEN LEFT CLICK AND "]
[null,"DOWN AND DRAG TO THE RIGHT."]
[]
[null,null,"OR"]
[]
[null,"METHOD  3"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE COPY/MOVE BUTTON, CLICK OR CHECK"]
[null,"THE CREATE A COPY BOX AND THEN CLICK ON OK."]
[]
[]
[null,"RENAME A WORKSHEET"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE RENAME BUTTON, THEN TYPE IN THE"]
[null,"NEW WORKSHEET NAME, ( some typing characters may not be allowed in a "]
[null,"name due to their formula type functions).   THEN PRESS ENTER."]
[]
[]
[null,"MOVING A WORKSHEET WITHIN A WORKBOOK."]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"LEFT CLICK AND HOLD DOWN, WITH THE BOTTON DOWN YOU CAN "]
[null,"MOVE THE CURSOR TO THE RIGHT OR LEFT TO POSITION THE "]
[null,"WORKSHEET TO THE NEEDED POSITION."]
[]
[]
[null,"Revision History"]
[]
[null,"Revision for 8/8/2002 - this is the first published version to have the dual formats,"]
[null,"with and without the lab worksheet incorporated"]
[null,"This version also has added a flag for the incentive/disincentive to warn when"]
[null,"a bid price has not been included"]
[null,"zzzz"]
[null,"Revision for 8/27/02 - fixed the buttons for the copying macros\nfixed the date fields to be shink to fit"]
[]
[]
[]
[null,"Revision for 11/13/02 - this version includes the manual overide for the number of "]
[null,"lots.  Leave \"0\" in the overide cell to accept the standard number of lots."]
[]
[null,"Revision for 11/14/02 - this version includes a facility for cutting and pasting data"]
[null,"into future revisions of this spread sheet.  This facility is made possible by the "]
[null,"following macros and buttons:  \"copy_data\", \"paste_data\", \"buttons_off\", "]
[null,null,"\"buttons_on\", \"copy_data_page2\", \"paste_data_page2\", "]
[null,null,"button_3, button_4, button_26, button_27, button_53, button_54"]
[null,"and the addition of another sheet: \"Sheet1\""]
[null,"The addition of these items to an old spread sheet should give it the facility "]
[null,"to paste data into a version of this spread sheet.  The formatting from the "]
[null,"respective sheets (\"combined\" and \"incentive\") should be pasted into the sheet"]
[null,"\"Sheet1\".  The formatting for \"incentive\" should be copied from \"A1:m53\" and pasted"]
[null,"to \"Sheet1\" starting at cell \"a1\".  The formatting for \"combined\" should be copied"]
[null,"from \"a1:r45\" and pasted to \"Sheet1\" starting at \"aa1\"."]
[]
[null,"Revision for 7/21/03 - this revision only effects the spread sheet if you are using "]
[null,"the weighted average of airvoids option.  Calculations of the weighted average "]
[null,"airvoids is causing error when blanks are used in the calculation.  Zeros are going"]
[null,"to be used as place holders, instead of \"\" blanks.  This will make the calculations"]
[null,"work.  A conditional format will make the zeros look invisible.  See the formulas"]
[null,"in cells D10:L11 for version I and cells D15:l16 for version II"]
[]
[null,"Revision for 9/4/03 - this revision reformated the \"notes\" fields.  I merged the "]
[null,"cells and set the format to \"word wrap\", and set the alignment to top/left."]
[]
[null,"Revision for 4/15/04 - this version has been changed to used the weighted average"]
[null,"percent air voids at production, versus the individual air voids"]
[]
[null,"Revision for 9/24/04 - this version is the first version to calculate the average"]
[null,"maximum specific gravitity for the day.  It also checks to see if there are more"]
[null,"than 2 max's for the day, and if there aren't, then it uses the moving average "]
[null,"of the max "]
[]
[null,"Revision for 7/21/05 - this version changes the dates to reflect specification "]
[null,"year 2005.  There are no functional changes to the spread sheet."]
[]
[null,"Revision for 8/11/05 - unprotected the workbook, multiple copies of the worksheet"]
[null,"can be made in one spread sheet"]
[]
[null,"Revision for 31JUL2006 - updated the year to 2006"]

{"sheet":"INSTRUCTIONS OLD","index":4,"n_rows":42,"n_cols":2,"rows_kept":42,"hidden":true,"merged":[[3,0,3,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
["IMPROVEMENTS TO THE INCENTIVE / DISINCENTIVE PROGRAM"]
[]
[null,"THIS PROGRAM HAS BEEN MODIFIED TO ALLOW WORKSHEETS"]
[null,"TO BE COPIED WITHIN THE WORKBOOK,  THEREFORE ONE"]
[null,"WORKBOOK (OR FILE) CAN CONTAIN SEVERAL DAYS OF PAVING."]
[]
[]
[null,"METHOD  1"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THE  "]
[null,"HOLD THE CTRL (CONTROL) DOWN AND THEN LEFT CLICK AND "]
[null,"DOWN AND DRAG TO THE RIGHT."]
[]
[]
[null,"METHOD  2"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO COPY, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE COPY/MOVE BUTTON, CLICK OR CHECK"]
[null,"THE CREATE A COPY BOX AND THEN CLICK ON OK."]
[]
[]
[null,"RENAME A WORKSHEET"]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"RIGHT CLICK, CLICK ON THE RENAME BUTTON, THEN TYPE IN THE"]
[null,"NEW WORKSHEET NAME, ( some typing characters may not be allowed in a "]
[null,"name due to their formula type functions).   THEN PRESS ENTER."]
[]
[]
[null,"MOVING A WORKSHEET WITHIN A WORKBOOK."]
[null,"CLICK TO THE WORKSHEET YOU WOULD LIKE TO RENAME, MOVE"]
[null,"THE CURSOR DOWN TO THE TAB AT THE BOTTOM OF THE SHEET,"]
[null,"THE CURSOR WILL CHANGE TO AN ARROW TYPE FORM, THEN  "]
[null,"LEFT CLICK AND HOLD DOWN, WITH THE BOTTON DOWN YOU CAN "]
[null,"MOVE THE CURSOR TO THE RIGHT OR LEFT TO POSITION THE "]
[null,"WORKSHEET TO THE NEEDED POSITION."]